USE [QuanLi]
GO

/****** Object:  Table [dbo].[NSLiLuanChinhTri]    Script Date: 12/04/2011 00:08:41 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[NSTrinhDoTinHoc](
	[TrinhDoTinHocID] [int] IDENTITY(1,1) NOT NULL,
	[NhanVienID] [int] NOT NULL,
	[LoaiTrinhDoTinHocID] [int] NOT NULL,
	[NgayHieuLuc] [datetime] NULL,
	[GhiChu] [nvarchar](200) NULL,
 CONSTRAINT [PK_NSTrinhDoTinHoc] PRIMARY KEY CLUSTERED 
(
	[TrinhDoTinHocID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

ALTER TABLE [dbo].[NSTrinhDoTinHoc]  WITH CHECK ADD  CONSTRAINT [FK_NSTrinhDoTinHoc_NSNhanVien] FOREIGN KEY([TrinhDoTinHocID])
REFERENCES [dbo].[NSNhanVien] ([NhanVienID])
GO

ALTER TABLE [dbo].[NSTrinhDoTinHoc] CHECK CONSTRAINT [FK_NSTrinhDoTinHoc_NSNhanVien]
GO

ALTER table nsnhanvien drop column TrinhDoTinHocID 


